What are the 5 types of SQL?
What are the 5 types of SQL?
234
27-Aug-2023
Updated on 28-Aug-2023
Aryan Kumar
28-Aug-2023There are 5 types of SQL commands, but let me introduce you to the 4 basic ones:
Data Definition Language (DDL): This type of command is used to create, alter, and drop database objects, such as tables, views, and stored procedures.
Data Manipulation Language (DML): This type of command is used to insert, update, delete, and select data from tables.
Data Query Language (DQL): This type of command is used to retrieve data from tables.
Transaction Control Language (TCL): This type of command is used to manage transactions, such as starting, committing, and rolling back transactions.
The fifth type of SQL command, Data Control Language (DCL), is not as commonly used as the other four. It is used to manage user access to databases, such as granting and revoking permissions.